//add fcounty for Florida
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
gen fcounty=.
replace fcounty=1 if county=="ALA" & state=="Florida"
replace fcounty=3 if county=="BAK" & state=="Florida"
replace fcounty=5 if county=="BAY" & state=="Florida"
replace fcounty=7 if county=="BRA" & state=="Florida"
replace fcounty=9 if county=="BRE" & state=="Florida"
replace fcounty=11 if county=="BRO" & state=="Florida"
replace fcounty=13 if county=="CAL" & state=="Florida"
replace fcounty=15 if county=="CHA" & state=="Florida"
replace fcounty=17 if county=="CIT" & state=="Florida"
replace fcounty=19 if county=="CLA" & state=="Florida"
replace fcounty=21 if county=="CLL" & state=="Florida"
replace fcounty=23 if county=="CLM" & state=="Florida"
replace fcounty=86 if county=="DAD" & state=="Florida"
replace fcounty=27 if county=="DES" & state=="Florida"
replace fcounty=29 if county=="DIX" & state=="Florida"
replace fcounty=31 if county=="DUV" & state=="Florida"
replace fcounty=33 if county=="ESC" & state=="Florida"
replace fcounty=35 if county=="FLA" & state=="Florida"
replace fcounty=37 if county=="FRA" & state=="Florida"
replace fcounty=39 if county=="GAD" & state=="Florida"
replace fcounty=41 if county=="GIL" & state=="Florida"
replace fcounty=43 if county=="GLA" & state=="Florida"
replace fcounty=45 if county=="GUL" & state=="Florida"
replace fcounty=47 if county=="HAM" & state=="Florida"
replace fcounty=49 if county=="HAR" & state=="Florida"
replace fcounty=51 if county=="HEN" & state=="Florida"
replace fcounty=53 if county=="HER" & state=="Florida"
replace fcounty=55 if county=="HIG" & state=="Florida"
replace fcounty=57 if county=="HIL" & state=="Florida"
replace fcounty=59 if county=="HOL" & state=="Florida"
replace fcounty=61 if county=="IND" & state=="Florida"
replace fcounty=63 if county=="JAC" & state=="Florida"
replace fcounty=65 if county=="JEF" & state=="Florida"
replace fcounty=67 if county=="LAF" & state=="Florida"
replace fcounty=69 if county=="LAK" & state=="Florida"
replace fcounty=71 if county=="LEE" & state=="Florida"
replace fcounty=73 if county=="LEO" & state=="Florida"
replace fcounty=75 if county=="LEV" & state=="Florida"
replace fcounty=77 if county=="LIB" & state=="Florida"
replace fcounty=79 if county=="MAD" & state=="Florida"
replace fcounty=81 if county=="MAN" & state=="Florida"
replace fcounty=87 if county=="MON" & state=="Florida"
replace fcounty=83 if county=="MRN" & state=="Florida"
replace fcounty=85 if county=="MRT" & state=="Florida"
replace fcounty=89 if county=="NAS" & state=="Florida"
replace fcounty=91 if county=="OKA" & state=="Florida"
replace fcounty=93 if county=="OKE" & state=="Florida"
replace fcounty=95 if county=="ORA" & state=="Florida"
replace fcounty=97 if county=="OSC" & state=="Florida"
replace fcounty=99 if county=="PAL" & state=="Florida"
replace fcounty=101 if county=="PAS" & state=="Florida"
replace fcounty=103 if county=="PIN" & state=="Florida"
replace fcounty=105 if county=="POL" & state=="Florida"
replace fcounty=107 if county=="PUT" & state=="Florida"
replace fcounty=113 if county=="SAN" & state=="Florida"
replace fcounty=115 if county=="SAR" & state=="Florida"
replace fcounty=117 if county=="SEM" & state=="Florida"
replace fcounty=109 if county=="STJ" & state=="Florida"
replace fcounty=111 if county=="STL" & state=="Florida"
replace fcounty=119 if county=="SUM" & state=="Florida"
replace fcounty=121 if county=="SUW" & state=="Florida"
replace fcounty=123 if county=="TAY" & state=="Florida"
replace fcounty=125 if county=="UNI" & state=="Florida"
replace fcounty=127 if county=="VOL" & state=="Florida"
replace fcounty=129 if county=="WAK" & state=="Florida"
replace fcounty=131 if county=="WAL" & state=="Florida"
replace fcounty=133 if county=="WAS" & state=="Florida"
